{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Generator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"The purpose of this spreadsheet is to generate the Tags and VBScript Code required to extract individual bit values from Tags for use in EcoStruxure Machine SCADA Expert Tags and Alarms worksheets.\nSee FAQ:\n\"In EcoStruxure Machine SCADA Expert, is it possible to trigger alarms with the individual bit states from a WORD /Integer address?\"\nhttps://www.se.com/ww/en/faqs/index?page=content&id=FA387220\n\nInstructions:\n1) Enable Macros in this spreadsheet.\n2) Go to the \"Generator\" Worksheet.\n3) Type your original Tagnames into the Orange Cells starting at cell B6.\n4) Enter a String to append to the end of the Tag in Cell B3.\n5) Press the Green button to the right.\n6) Copy from the gray cells in Column D into your EcoStruxure Machine SCADA Expert project's Project Tag Worksheet.\n7) Copy from the gray cells in Column D into your EcoStruxure Machine SCADA Expert project's Alarm Worksheet.\n8) Copy from the gray cells in Column E into your EcoStruxure Machine SCADA Expert project's VBScript page."]

{"sheet":"Generator","index":1,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,"String to append:"]
[null,"_BitPosition"]
[]
[null,"Tagnames (16bit Words) to extract bits from",null,"Output Array Variables (16 bits from row B)","VBScript code to extract bits from original Tags to the Arrays of Bits"]
[null,"TagA",null,"TagA_BitPosition[0]","$TagA_BitPosition[0] = $TagA->B0"]
[null,"TagB",null,"TagA_BitPosition[1]","$TagA_BitPosition[1] = $TagA->B1"]
[null,"TagC",null,"TagA_BitPosition[2]","$TagA_BitPosition[2] = $TagA->B2"]
[null,null,null,"TagA_BitPosition[3]","$TagA_BitPosition[3] = $TagA->B3"]
[null,null,null,"TagA_BitPosition[4]","$TagA_BitPosition[4] = $TagA->B4"]
[null,null,null,"TagA_BitPosition[5]","$TagA_BitPosition[5] = $TagA->B5"]
[null,null,null,"TagA_BitPosition[6]","$TagA_BitPosition[6] = $TagA->B6"]
[null,null,null,"TagA_BitPosition[7]","$TagA_BitPosition[7] = $TagA->B7"]
[null,null,null,"TagA_BitPosition[8]","$TagA_BitPosition[8] = $TagA->B8"]
[null,null,null,"TagA_BitPosition[9]","$TagA_BitPosition[9] = $TagA->B9"]
[null,null,null,"TagA_BitPosition[10]","$TagA_BitPosition[10] = $TagA->B10"]
[null,null,null,"TagA_BitPosition[11]","$TagA_BitPosition[11] = $TagA->B11"]
[null,null,null,"TagA_BitPosition[12]","$TagA_BitPosition[12] = $TagA->B12"]
[null,null,null,"TagA_BitPosition[13]","$TagA_BitPosition[13] = $TagA->B13"]
[null,null,null,"TagA_BitPosition[14]","$TagA_BitPosition[14] = $TagA->B14"]
[null,null,null,"TagA_BitPosition[15]","$TagA_BitPosition[15] = $TagA->B15"]
[null,null,null,"TagB_BitPosition[0]","$TagB_BitPosition[0] = $TagB->B0"]
[null,null,null,"TagB_BitPosition[1]","$TagB_BitPosition[1] = $TagB->B1"]
[null,null,null,"TagB_BitPosition[2]","$TagB_BitPosition[2] = $TagB->B2"]
[null,null,null,"TagB_BitPosition[3]","$TagB_BitPosition[3] = $TagB->B3"]
[null,null,null,"TagB_BitPosition[4]","$TagB_BitPosition[4] = $TagB->B4"]
[null,null,null,"TagB_BitPosition[5]","$TagB_BitPosition[5] = $TagB->B5"]
[null,null,null,"TagB_BitPosition[6]","$TagB_BitPosition[6] = $TagB->B6"]
[null,null,null,"TagB_BitPosition[7]","$TagB_BitPosition[7] = $TagB->B7"]
[null,null,null,"TagB_BitPosition[8]","$TagB_BitPosition[8] = $TagB->B8"]
[null,null,null,"TagB_BitPosition[9]","$TagB_BitPosition[9] = $TagB->B9"]
[null,null,null,"TagB_BitPosition[10]","$TagB_BitPosition[10] = $TagB->B10"]
[null,null,null,"TagB_BitPosition[11]","$TagB_BitPosition[11] = $TagB->B11"]
[null,null,null,"TagB_BitPosition[12]","$TagB_BitPosition[12] = $TagB->B12"]
[null,null,null,"TagB_BitPosition[13]","$TagB_BitPosition[13] = $TagB->B13"]
[null,null,null,"TagB_BitPosition[14]","$TagB_BitPosition[14] = $TagB->B14"]
[null,null,null,"TagB_BitPosition[15]","$TagB_BitPosition[15] = $TagB->B15"]
[null,null,null,"TagC_BitPosition[0]","$TagC_BitPosition[0] = $TagC->B0"]
[null,null,null,"TagC_BitPosition[1]","$TagC_BitPosition[1] = $TagC->B1"]
[null,null,null,"TagC_BitPosition[2]","$TagC_BitPosition[2] = $TagC->B2"]
[null,null,null,"TagC_BitPosition[3]","$TagC_BitPosition[3] = $TagC->B3"]
[null,null,null,"TagC_BitPosition[4]","$TagC_BitPosition[4] = $TagC->B4"]
[null,null,null,"TagC_BitPosition[5]","$TagC_BitPosition[5] = $TagC->B5"]
[null,null,null,"TagC_BitPosition[6]","$TagC_BitPosition[6] = $TagC->B6"]
[null,null,null,"TagC_BitPosition[7]","$TagC_BitPosition[7] = $TagC->B7"]
[null,null,null,"TagC_BitPosition[8]","$TagC_BitPosition[8] = $TagC->B8"]
[null,null,null,"TagC_BitPosition[9]","$TagC_BitPosition[9] = $TagC->B9"]
[null,null,null,"TagC_BitPosition[10]","$TagC_BitPosition[10] = $TagC->B10"]
[null,null,null,"TagC_BitPosition[11]","$TagC_BitPosition[11] = $TagC->B11"]
[null,null,null,"TagC_BitPosition[12]","$TagC_BitPosition[12] = $TagC->B12"]
[null,null,null,"TagC_BitPosition[13]","$TagC_BitPosition[13] = $TagC->B13"]
[null,null,null,"TagC_BitPosition[14]","$TagC_BitPosition[14] = $TagC->B14"]
[null,null,null,"TagC_BitPosition[15]","$TagC_BitPosition[15] = $TagC->B15"]